﻿-- =============================================
-- Author:		<赵洪涛>
-- Create date: <2012-02-11>
-- Description:	<修改成单项>
-- =============================================
CREATE PROCEDURE [dbo].[proc_Order_Item_Update] 
	(
		@Id int
		,@ProductId	int
		,@ProductName	nvarchar(50)
		,@UnitPrice	decimal(18, 2)
		,@Quantity	int
		,@Description nvarchar(200)
	)
AS
	Begin
		Update Order_Item Set ProductId=@ProductId,
ProductName=@ProductName,
UnitPrice=@UnitPrice,
Quantity=@Quantity,
Description=@Description
Where Id=@Id
	End
RETURN